USE [DentalSoftware]
GO

/****** Object:  Table [dbo].[BenhNhan]    Script Date: 09/01/2011 09:58:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BenhNhan](
	[Ma] [int] IDENTITY(1,1) NOT NULL,
	[HoTen] [nvarchar](50) NULL,
	[GioiTinh] [int] NULL,
	[NgaySinh] [datetime] NULL,
	[DiaChi] [nvarchar](100) NULL,
	[MaQuan] [int] NULL,
	[DienThoai] [nchar](50) NULL,
	[MaNgheNghiep] [int] NULL,
	[MaLoai] [int] NULL,
	[KhamDinhKi] [int] NULL,
	[HinhAnh] [nvarchar](50) NULL,
	[TienDaThanhToan] [float] NULL,
	[TienConNo] [float] NULL,
 CONSTRAINT [PK_BenhNhan] PRIMARY KEY CLUSTERED 
(
	[Ma] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

